UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '42c5nzdi6fHfpWAhMxODkob3ZZF0Y3J3E5CBLGk68Gs='
WHERE
key_id = '65886dd86de1b7e1801f4579b2d36700a40b249242109f7f108c333c357ce2ff'
AND (
token = '42c5nzdi6fHfpWAhMxODkob3ZZF0Y3J3E5CBLGk68Gs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)