UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'cPfMvJjVJEoXiCqFeRJ7HEf7B1KEnJSJFk9z6Fczn0U='
WHERE
key_id = 'd2d9dc387d2619aeb5c7743610a4a87a4611f21c425145a3111015cf5abbcbe5'
AND (
token = 'cPfMvJjVJEoXiCqFeRJ7HEf7B1KEnJSJFk9z6Fczn0U='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)