UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JDo6GHVjSsPdH1tTg9I5GDebyGPf1nSGEDcJhapBf/s='
WHERE
key_id = '073d7eab572518013d67c35ceb0510eb0c8e4b97a8a4d52abffe54b288789a71'
AND (
token = 'JDo6GHVjSsPdH1tTg9I5GDebyGPf1nSGEDcJhapBf/s='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)