UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'WVFym6qEMSIUwHH+70TYQtr2i4w34danVAS2+rEFVHI='
WHERE
key_id = 'c4b4cd260e9f5ff379a5f497b337d52d9f987de82250d6e1d4db2faf13ebd00d'
AND (
token = 'WVFym6qEMSIUwHH+70TYQtr2i4w34danVAS2+rEFVHI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)