UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5X7vvWg+R4hYsU39BCUBnHCcjQZ8p4Z8nFNZvlZcX90='
WHERE
key_id = 'dd6495f29462c392d5f141527dddb99e69ba7e20c049304bbe45ba963fa17d03'
AND (
token = '5X7vvWg+R4hYsU39BCUBnHCcjQZ8p4Z8nFNZvlZcX90='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)