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