UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'U6GWi4FKqEbzRpuXwyJZLqHj63E5IyhTpWkmL1vCjHg='
WHERE
key_id = '8c3c5d182d1a56121da2503a3fa257fb4251bd5549d01c341ba219867f148b4a'
AND (
token = 'U6GWi4FKqEbzRpuXwyJZLqHj63E5IyhTpWkmL1vCjHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)