UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D4RwydS3u48dVQCigs+sspV3Wa8sKbhDjlZg3459Xi8='
WHERE
key_id = '1785f588856380789128f5adfcf1ec2279f5844bf6dcab57d06bf951a3303631'
AND (
token = 'D4RwydS3u48dVQCigs+sspV3Wa8sKbhDjlZg3459Xi8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)