UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2tf2waddDIjlK9OmBauienNu83eG/w8CckPRx4zZVCI='
WHERE
key_id = '038fd619a15d3c188b80187543cc313618685cd87d90f1bd59e3a5587f73fbb9'
AND (
token = '2tf2waddDIjlK9OmBauienNu83eG/w8CckPRx4zZVCI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)