UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nSK8YrxeuwlJYoOW+lTJjXx1PcxDM1+CWByOIyfs7QQ='
WHERE
key_id = 'a8a7fb10e726b729a0818f18564cab2b04248357db8c37b2dd29546e763d302f'
AND (
token = 'nSK8YrxeuwlJYoOW+lTJjXx1PcxDM1+CWByOIyfs7QQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)