UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HBywcJYsC7HLWlxIyYh8nOGEjm9e9K7keIQQNw2x2fQ='
WHERE
key_id = '4a598797b676a51e99d246b87a6eca8516a7ecf8cdea83f2626ebfbfa2da344a'
AND (
token = 'HBywcJYsC7HLWlxIyYh8nOGEjm9e9K7keIQQNw2x2fQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)