UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BeJJqxb8Ba9NUEgHAyTZVhcklxGu6OAn86VGn4wsSb4='
WHERE
key_id = 'a9f798723f65d5b8ef8ee10214858dca47f4d4f19b80f33ab8f25f1217a30f3a'
AND (
token = 'BeJJqxb8Ba9NUEgHAyTZVhcklxGu6OAn86VGn4wsSb4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)