UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QZyvdIACNArsQ3ATt90wDuv2Ep+HuV9sF0d+Cs1Pqw0='
WHERE
key_id = 'e5af37ee79af772908267d1889d23ed5e81d3b66eea238e73ea8774fbe0f204f'
AND (
token = 'QZyvdIACNArsQ3ATt90wDuv2Ep+HuV9sF0d+Cs1Pqw0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)