UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C/TEs0CnbvM4hjudrC0Nt4nExxbOL2kC1N2ell3d7L8='
WHERE
key_id = 'b3eb105a11e84b6023113f14ac6aefb3f5429d87da594c5f6ddeda8bd8d83dd7'
AND (
token = 'C/TEs0CnbvM4hjudrC0Nt4nExxbOL2kC1N2ell3d7L8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)