UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4AVNTSY18yCCEFrG8RIrPTEFDcwyn5rGUTbelFqY4As='
WHERE
key_id = 'fdf1672591a65b91c58aa6a258bf62739d4f2f32ffdd8f4d9081ee40a2e9e24b'
AND (
token = '4AVNTSY18yCCEFrG8RIrPTEFDcwyn5rGUTbelFqY4As='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)