UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'LfOkwsiRvkl8kjVSKLDSe00ZXwmIHdvrGA4qh18DVlE='
WHERE
key_id = '2f045c39f0b45bdb0108070da56c9a225d3c418a0e03205d7a02c2532560f387'
AND (
token = 'LfOkwsiRvkl8kjVSKLDSe00ZXwmIHdvrGA4qh18DVlE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)