UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7AO0jrlL25Y12loB3c9ldlfnrsEGzFLjuUk3t8Z67ZE='
WHERE
key_id = 'b82b0a5e5e6a45834337f1d9169ae666ff35f8a636b13242676226abfe82a69a'
AND (
token = '7AO0jrlL25Y12loB3c9ldlfnrsEGzFLjuUk3t8Z67ZE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)