UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dDWUajTlM7A3/R53ZJo+zAKRpLKEEmijeTQaZ1IShG8='
WHERE
key_id = 'de4767e78997e03518470d84a68a6c6726006c79adbbaea49633fd39924d4adf'
AND (
token = 'dDWUajTlM7A3/R53ZJo+zAKRpLKEEmijeTQaZ1IShG8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)