UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XuKcmNbqqzAarvyt8XcBLsjAdFMPDopiCEU7CyxsxAA='
WHERE
key_id = '10981ce7b5acfa58fb4c3d739ad85d2aa3da7e834309a904f69af725094158ee'
AND (
token = 'XuKcmNbqqzAarvyt8XcBLsjAdFMPDopiCEU7CyxsxAA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)