UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gHEgnVDlnjzRISdbbqFUxsEqG50AeTgPcUNlXL5Kg0w='
WHERE
key_id = '6b0e2381cb5d931066d3dabed4228651ce725a0baecd2d4c85c471a29d7bc99f'
AND (
token = 'gHEgnVDlnjzRISdbbqFUxsEqG50AeTgPcUNlXL5Kg0w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)