UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QLDrz+246FK9s+mItWHEsOBDw/L8CalZj/NyBBvpbRA='
WHERE
key_id = '418a75a00ecdaf5394f9fabd3bff6eb6648a5f1aeb8da63d643d5a6976942400'
AND (
token = 'QLDrz+246FK9s+mItWHEsOBDw/L8CalZj/NyBBvpbRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)