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