UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1yXZwkPfbyqAojcQ3zojqJ1wOqhnOLv33EanXRe5HEk='
WHERE
key_id = 'e27401fe8f403ed39760e2b49c70e8690f9a02df4ece001e7d1cf0895fb02b3a'
AND (
token = '1yXZwkPfbyqAojcQ3zojqJ1wOqhnOLv33EanXRe5HEk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)