UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'P65Sy/YDH1EWvv83B/tJQcPV3yc0dgvvXizk3P2GNm8='
WHERE
key_id = '6ca980a39a122620f3db617f073c831272dc4c921c6f797916a37ef3965f4586'
AND (
token = 'P65Sy/YDH1EWvv83B/tJQcPV3yc0dgvvXizk3P2GNm8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)