UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2aBm/16EcoWFlXMliaS8tBoEgD1nWt88cXgvN7eR4cI='
WHERE
key_id = 'e462f5f17593fb9ded6e4edb1135c32970e5f00179045d67d58ceb4b5cde169e'
AND (
token = '2aBm/16EcoWFlXMliaS8tBoEgD1nWt88cXgvN7eR4cI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)