UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QOaYnatb/iAfEUWwcAubLUO67pjX3VyVK/QT6RirYuA='
WHERE
key_id = 'ca5cbf97293e3b40e208758aa454c198be7731f725f259a6c045deba53f8310d'
AND (
token = 'QOaYnatb/iAfEUWwcAubLUO67pjX3VyVK/QT6RirYuA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)