UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KKawHRZk+V5YHOeDD1DbpBoiCTerbe4bWUieIZZxmkU='
WHERE
key_id = 'd30d2223a2da3fdd0e98e854c0c5ad887da48c6bd5a9b7e05185908027dac2ec'
AND (
token = 'KKawHRZk+V5YHOeDD1DbpBoiCTerbe4bWUieIZZxmkU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)