UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9dFKGkfue5DYa7DLrqR4Ghft/JVuxwEhZZA5hsGUT5I='
WHERE
key_id = 'fdaca2cd1f721e18e8f50d6731513d2b7fce494b10fed89a58cc8edf3ccb1dd7'
AND (
token = '9dFKGkfue5DYa7DLrqR4Ghft/JVuxwEhZZA5hsGUT5I='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)