UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YD7qPn6cTCUV2zyzhmfyMOAQgOeyWWtzbnaCnNL83o0='
WHERE
key_id = '8378331e2c5a4602132df6a526809a37d8ee211ce8c3c69876c576bcf0fcb2e2'
AND (
token = 'YD7qPn6cTCUV2zyzhmfyMOAQgOeyWWtzbnaCnNL83o0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)