UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '1+XjD9OGYpo2U0g/5yKBcsC5BcQweUUz64USpf4h+UE='
WHERE
key_id = '28371dd961659e9b437cac04729f4ac51660b3c6f4c0948faca69ba230ac0bf1'
AND (
token = '1+XjD9OGYpo2U0g/5yKBcsC5BcQweUUz64USpf4h+UE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)