UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'HatXX1Mt33axFzK38sEPE2wBWkyIrwdt34HoyHtowBI='
WHERE
key_id = '584e283f45d2278ea109e410e84c775d366550678b9f9aafa3fbadc8b695370f'
AND (
token = 'HatXX1Mt33axFzK38sEPE2wBWkyIrwdt34HoyHtowBI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)