UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LfRe5G8gA1JudQM9lMRy4zdcNhnb9Nmecjh3qbrYbpk='
WHERE
key_id = '3c059c3452d8fcc6294c736e4e395ea2d7f7e8ef5d1545ddd554bee170382238'
AND (
token = 'LfRe5G8gA1JudQM9lMRy4zdcNhnb9Nmecjh3qbrYbpk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)