UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/8MNilMUCcBQpJBBIVbctAnU4AtVrMv3LB7BoE+nFrk='
WHERE
key_id = '47edfdf113b55da69fb4585863335d6a93abdf49e9ceb462626a030f6276b2b2'
AND (
token = '/8MNilMUCcBQpJBBIVbctAnU4AtVrMv3LB7BoE+nFrk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)